Searches the text in the argument in-text for a character or series of characters specified in the find-text argument. It starts at the character position represented by start-offset and returns the starting position of find-text. The search is case-sensitive and blanks are counted.
Format: FIND (find-text, in-text {,start-offset})
Arguments:
ΓÇó find-text: The text expression you want to find. Enclose text in quotation marks.
ΓÇó in-text: The text expression that you want searched. Enclose text in quotation marks.
ΓÇó start-offset: Optional. Must be a numeric expression greater than or equal to 0.
Example:
FIND ("e", "where on the Earth") returns 3.
Shows that e is the third character in the text phrase, "where on the Earth".